home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Freelog Special Freeware 31
/
FreelogHS31.iso
/
ArgentCompta
/
FASTCAISSE
/
Setup FASTCAISSE.exe
/
{app}
/
A Faire43.SQL
< prev
next >
Wrap
Text File
|
2003-11-15
|
2KB
|
71 lines
DELETE FROM CHAINES WHERE TYPEC=14 OR TYPEC=16;
ALTER TABLE LIGNES DROP COMMENTAIRE;
CREATE TABLE "PRIXVENTE"
(
"INDXART" INTEGER NOT NULL,
"TARIF" SMALLINT DEFAULT 1 NOT NULL,
"COEF" "COEFF",
"PRIX" "EURO",
"DATEMODIF" DATE,
PRIMARY KEY ("INDXART","TARIF")
);
ALTER TABLE "PRIXVENTE" ADD CONSTRAINT "CON_PRIXVENTE" FOREIGN KEY ("INDXART") REFERENCES "ARTICLES" ("INDX")ON UPDATE CASCADE ON DELETE CASCADE;
CREATE TRIGGER "TRI_PRIXVENTE" FOR "PRIXVENTE"
ACTIVE BEFORE UPDATE POSITION 0
as
begin
new."DATEMODIF" = 'NOW';
end
;
INSERT INTO PRIXVENTE (INDXART,TARIF,COEF,PRIX,DATEMODIF) SELECT INDX,1,COEF1,PRIX1,DATEMODIF FROM ARTICLES where coef1<>0 OR prix1<>0;
INSERT INTO PRIXVENTE (INDXART,TARIF,COEF,PRIX,DATEMODIF) SELECT INDX,2,COEF2,PRIX2,DATEMODIF FROM ARTICLES where coef2<>0 OR prix2<>0;
INSERT INTO PRIXVENTE (INDXART,TARIF,COEF,PRIX,DATEMODIF) SELECT INDX,3,COEF3,PRIX3,DATEMODIF FROM ARTICLES where coef3<>0 OR prix3<>0;
ALTER TABLE ARTICLES DROP PRIX1;
ALTER TABLE ARTICLES DROP PRIX2;
ALTER TABLE ARTICLES DROP PRIX3;
ALTER TABLE ARTICLES DROP COEF1;
ALTER TABLE ARTICLES DROP COEF2;
ALTER TABLE ARTICLES DROP COEF3;
CREATE INDEX IDX_RAYON ON ARTICLES (RAYON);
CREATE PROCEDURE "GET_R123"
(
"INDX" INTEGER
)
RETURNS
(
"R1" VARCHAR(40),
"R2" VARCHAR(40),
"R3" VARCHAR(40)
)
AS
DECLARE VARIABLE V1 VARCHAR(50);
DECLARE VARIABLE N1 SMALLINT;
DECLARE VARIABLE N2 SMALLINT;
DECLARE VARIABLE N3 SMALLINT;
BEGIN
SELECT RY1,RY2,RY3 FROM RAYONS WHERE PKEY = :INDX INTO :N1,:N2,:N3;
SELECT NOMRAYON FROM RAYONS WHERE (RY1=:N1) AND (RY2=0) AND (RY3=0) INTO :R1;
if (n2<>0) then
begin
SELECT NOMRAYON FROM RAYONS WHERE (RY1=:N1) AND (RY2=:N2) AND (RY3=0) INTO :R2;
end
else
begin
R2 = '';
end
if (n3<>0) then
begin
SELECT NOMRAYON FROM RAYONS WHERE (RY1=:N1) AND (RY2=:N2) AND (RY3=:N3) INTO :R3;
end
else
begin
R3 = '';
end
SUSPEND;
END
;
SET GENERATOR VERSION_BASE TO 43;